Text copied to clipboard!
Title
Text copied to clipboard!SQL Server DBA
Description
Text copied to clipboard!
We are looking for a skilled SQL Server DBA to join our dynamic team. The ideal candidate will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications. This is a 'hands-on' position requiring solid technical skills, as well as excellent interpersonal and communication skills. The successful candidate will be responsible for the development and sustainment of the SQL Server environment, ensuring its operational readiness (security, health, and performance), executing data loads, and performing data modeling in support of multiple development teams. The candidate must be capable of working independently and collaboratively. The role requires a service-oriented mentality, high sense of ownership of the problems and requests assigned, focus on managing and resolving issues in alignment with the SLAs, establishing and maintaining communication with technology customers to keep them updated with the status of their requests, initiating and performing changes on production systems, and proactively escalating any issues that cannot be resolved within the established timeframes.
Responsibilities
Text copied to clipboard!- Install, configure, and maintain SQL Server instances.
- Ensure high levels of performance, availability, sustainability, and security.
- Analyze, solve, and correct issues in real-time.
- Refine and automate regular processes, track issues, and document changes.
- Assist developers with complex query tuning and schema refinement.
- Provide 24x7 support for critical production systems.
- Perform scheduled maintenance and support release deployment activities after hours.
- Implement and maintain database security (create and maintain users and roles, assign privileges).
- Perform database tuning and performance monitoring.
- Plan and implement backup and recovery strategies.
- Develop and maintain documentation for database configurations, procedures, and processes.
- Collaborate with other team members and stakeholders.
- Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
- Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
- Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
Requirements
Text copied to clipboard!- Bachelor's degree in Computer Science or a related field.
- 5+ years of experience as a SQL Server DBA or similar role.
- Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
- Experience with backups, restores, and recovery models.
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
- Experience with Windows server, including Active Directory.
- Excellent written and verbal communication.
- Flexible, team player, 'get-it-done' personality.
- Ability to organize and plan work independently.
- Ability to work in a rapidly changing environment.
- Ability to multi-task and context-switch effectively between different activities and teams.
- MCSA, MCSE, or other related certifications are a plus.
- Experience with cloud services (AWS, Azure) is a plus.
- Knowledge of other database systems (MySQL, PostgreSQL) is a plus.
- Experience with automation tools and scripting languages (PowerShell, Python) is a plus.
Potential interview questions
Text copied to clipboard!- Can you describe your experience with SQL Server performance tuning?
- How do you handle database backup and recovery?
- What strategies do you use for database security?
- Can you provide an example of a complex query you optimized?
- How do you manage high availability and disaster recovery for SQL Server?
- Describe a challenging database issue you resolved.
- What tools do you use for monitoring SQL Server performance?
- How do you stay updated with the latest SQL Server technologies?
- Can you explain your experience with cloud-based SQL Server solutions?
- How do you handle database schema changes in a production environment?